﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class CommunityFinance : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["CommunityUser"] == null)
        {
            Response.Redirect("Community.aspx");
        }
        this.SqlDataSource1.SelectCommand = "SELECT [RemainMoney], [Cent] FROM [GowllUsers] WHERE [ID]="+Session["CommunityUserID"];
        this.SqlDataSource2.SelectCommand = "SELECT [GowllCommunityOrders].[ID],[GowllCommunityOrders].[CommunityID], [GowllCommunitys].[Title], [GowllCommunitys].[Price],[GowllCommunityOrders].[StartDate] FROM [GowllCommunitys],[GowllCommunityOrders] WHERE [GowllCommunityOrders].[Payed]=1 and [GowllCommunityOrders].[CommunityID]=[GowllCommunitys].[ID] and [GowllCommunityOrders].[UserID]=" + Session["CommunityUserID"] + " ORDER BY [GowllCommunityOrders].[StartDate] DESC ";
        this.GridView1.DataBind();
    }
}
